home *** CD-ROM | disk | FTP | other *** search
/ Winzipper / Winzipper_ISO.iso / programming / oracle7 7.2 / DB / UTIL72 / CATSTATC.SQL < prev    next >
Encoding:
Text File  |  1995-05-09  |  3.4 KB  |  62 lines
  1. rem 
  2. rem $Header: catstatc.sql 7020100.1 94/09/23 22:14:21 cli Generic<base> $ 
  3. rem 
  4. Rem  Copyright (c) 1991 by Oracle Corporation 
  5. Rem    NAME
  6. Rem      catstatc.sql
  7. Rem    DESCRIPTION
  8. Rem      Compute statistics for all dictionary clusters and tables.
  9. Rem    NOTES
  10. Rem      Must be connected as sys or internal.
  11. Rem    MODIFIED   (MM/DD/YY)
  12. Rem     tpystyne   11/06/92 -  Creation
  13.  
  14. analyze cluster C_COBJ# compute statistics;                       
  15. analyze cluster C_FILE#_BLOCK# compute statistics;                
  16. analyze cluster C_MLOG# compute statistics;                       
  17. analyze cluster C_OBJ# compute statistics;                        
  18. analyze cluster C_TS# compute statistics;                         
  19. analyze cluster C_USER# compute statistics;                       
  20. analyze cluster HIST$ compute statistics;                         
  21.  
  22. analyze table ACCESS$ compute statistics;                       
  23. analyze table AUD$ compute statistics;                          
  24. analyze table AUDIT$ compute statistics;                        
  25. analyze table BOOTSTRAP$ compute statistics;                    
  26. analyze table COM$ compute statistics;                          
  27. analyze table CON$ compute statistics;                          
  28. analyze table DEFROLE$ compute statistics;                      
  29. analyze table DEPENDENCY$ compute statistics;                   
  30. analyze table DUAL compute statistics;                          
  31. analyze table ERROR$ compute statistics;                        
  32. analyze table FILE$ compute statistics;                         
  33. analyze table IDL_CHAR$ compute statistics;                     
  34. analyze table IDL_SB4$ compute statistics;                      
  35. analyze table IDL_UB1$ compute statistics;                      
  36. analyze table IDL_UB2$ compute statistics;                      
  37. analyze table INCEXP compute statistics;                        
  38. analyze table INCFIL compute statistics;                        
  39. analyze table INCVID compute statistics;                        
  40. analyze table LAB$ compute statistics;                          
  41. analyze table LINK$ compute statistics;                         
  42. analyze table OBJ$ compute statistics;                          
  43. analyze table OBJAUTH$ compute statistics;                      
  44. analyze table PENDING_SESSIONS$ compute statistics;             
  45. analyze table PENDING_SUB_SESSIONS$ compute statistics;         
  46. analyze table PENDING_TRANS$ compute statistics;                
  47. analyze table PROCEDURE$ compute statistics;                    
  48. analyze table PROFILE$ compute statistics;                      
  49. analyze table PROFNAME$ compute statistics;                     
  50. analyze table PROPS$ compute statistics;                        
  51. analyze table RESOURCE_COST$ compute statistics;                
  52. analyze table SEQ$ compute statistics;                          
  53. analyze table SNAP$ compute statistics;                         
  54. analyze table SOURCE$ compute statistics;                       
  55. analyze table SYN$ compute statistics;                          
  56. analyze table SYSAUTH$ compute statistics;                      
  57. analyze table TRIGGER$ compute statistics;                      
  58. analyze table TRIGGERCOL$ compute statistics;                   
  59. analyze table UNDO$ compute statistics;                         
  60. analyze table VIEW$ compute statistics;                         
  61. analyze table "_default_auditing_options_" compute statistics;    
  62.